/*
 *  Copyright 2010 mazhao.
 * 
 *  Licensed under the Apache License, Version 2.0 (the "License");
 *  you may not use this file except in compliance with the License.
 *  You may obtain a copy of the License at
 * 
 *       http://www.apache.org/licenses/LICENSE-2.0
 * 
 *  Unless required by applicable law or agreed to in writing, software
 *  distributed under the License is distributed on an "AS IS" BASIS,
 *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *  See the License for the specific language governing permissions and
 *  limitations under the License.
 *  under the License.
 */

package shopping.model;

import org.apache.ibatis.session.SqlSession;

import java.util.List;

/**
 * @author mazhao
 */
public class Province extends ProvinceData {
    public Province() {
    }

    public Province(int id, String name, String description) {
        super(id, name, description);
    }

    /**
     * get all provinces
     * @return list of provinces
     */
    public static List<Province> getAll() {
        String sqlKey = "shopping.model.Province.getAll";
        SqlSession session = getSession();
        List<Province> provinces = session.selectList(sqlKey);
        session.close();
        return provinces;
    }

    /*
    public List<Province> getAll() {
        String sqlKey = getClassName() + "." + getCallerMethodName();
        log.debug("sql key " + sqlKey);

        if (autoTrans) {
            session = getSession();
        }

        List<Province> ps = session.selectList(sqlKey);

        if (log.isDebugEnabled()) {
            log.debug("order item count " + ps.size());
            for (Province p : ps) {
                log.debug(p);
            }
        }

        if (autoTrans) {
            session.close();
        }

        return ps;
    }
    */
}
